Report created by A.J. Brown - Ansley.Brown@colostate.edu\ 5 September 2022\ Using Python 3.9.6\ Jupyter Lab 3.2.1\ Script Version 0.7
The following script is a data report containing water quality data from samples taken in 2021 in the Yampa River Valley by the Colorado State University (CSU) Agriculture Water Quality Program (AWQP). For more information, please contact Erik Wardle at Erik.Wardle@colostate.edu or visit the CSU AWQP Website at https://waterquality.colostate.edu.
All samples were identified via "Sample ID" prefix using abbreviations corresponding to locations as noted in the legend below:
| Sample ID | Location |
|---|---|
| SB-SCI | Stagecoach Inlet |
| SB-SCA | Stagecoach Resevoir |
| SB-SCB | Stagecoach Spillway |
| SB-DS | Ranch |
| SB-CM | Catamount |
Use the interactive map below to look at samples taken. Hovering over points will show all parameters collected on site.
Use the below boxplot to graph various water analytes stratified by sample type (i.e., Inflow, Outflow, etc.). Analytes can be selected by using the dropdown menu on the top left of the graph. Hover over points with your mouse for additional information.
Use the below Scatter plot to graph various water analytes against each other to see potential relationships. Analytes can be selected by using the dropdown menus near top left of the graph. Hover over points with your mouse for additional information.
Use the below scatter matrix to look at potential relationships between numerical variables.
Points are stratified by sample type (i.e., Inflow, Outflow, etc.).
Hover over points with your mouse for additional information.
| Location | Date | Irr./Storm Event | Sample Type | Replication ID | Sample ID | Orthophosphate (mg/L) | NO3 (mg/L) | NH4 (mg/L) | TKN (mg/L) | ... | Selenium (mg/L) | E. coli. (Ct./100 mL) | Fecal Coliform (Ct./100 mL) | TSS (g/L) | Flow (GPM) | Latitude | Longitude | Notes | Year | hex | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Yampa Valley | 6/14/2021 | Grab 1 | SCI | 1 | SB-SCI-01-GB | NaN | NaN | NaN | 1.50 | ... | NaN | NaN | NaN | 80.000000 | NaN | 40.285280 | -106.846751 | NaN | 2021 | #1f77b4 |
| 1 | Yampa Valley | 6/14/2021 | Grab 1 | SCI | 2 | SB-SCI-01-GB-D | NaN | NaN | NaN | 1.10 | ... | NaN | NaN | NaN | 103.333333 | NaN | 40.285280 | -106.846751 | NaN | 2021 | #1f77b4 |
| 2 | Yampa Valley | 6/14/2021 | Grab 1 | SCA | 1 | SB-SCA-01-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 10.000000 | NaN | 40.268871 | -106.883927 | NaN | 2021 | #ff7f0e |
| 3 | Yampa Valley | 6/14/2021 | Grab 1 | SCA | 2 | SB-SCA-01-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 16.666667 | NaN | 40.268871 | -106.883927 | NaN | 2021 | #ff7f0e |
| 4 | Yampa Valley | 6/14/2021 | Grab 1 | SCB | 1 | SB-SCB-01-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 10.000000 | NaN | 40.285571 | -106.829854 | NaN | 2021 | #2ca02c |
| 5 | Yampa Valley | 6/14/2021 | Grab 1 | SCB | 2 | SB-SCB-01-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 10.000000 | NaN | 40.285571 | -106.829854 | NaN | 2021 | #2ca02c |
| 6 | Yampa Valley | 6/14/2021 | Grab 1 | DS | 1 | SB-DS-01-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 10.000000 | NaN | 40.289025 | -106.819500 | NaN | 2021 | #d62728 |
| 7 | Yampa Valley | 6/14/2021 | Grab 1 | DS | 2 | SB-DS-01-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 13.333333 | NaN | 40.289025 | -106.819500 | NaN | 2021 | #d62728 |
| 8 | Yampa Valley | 7/28/2021 | Grab 2 | SCI | 1 | SB-SCI-02-GB | NaN | NaN | NaN | 0.93 | ... | NaN | NaN | NaN | 40.000000 | NaN | 40.285280 | -106.846751 | NaN | 2021 | #1f77b4 |
| 9 | Yampa Valley | 7/28/2021 | Grab 2 | SCI | 2 | SB-SCI-02-GB-D | NaN | NaN | NaN | 1.90 | ... | NaN | NaN | NaN | 26.666667 | NaN | 40.285280 | -106.846751 | NaN | 2021 | #1f77b4 |
| 10 | Yampa Valley | 7/28/2021 | Grab 2 | SCA | 1 | SB-SCA-02-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 13.333333 | NaN | 40.268871 | -106.883927 | NaN | 2021 | #ff7f0e |
| 11 | Yampa Valley | 7/28/2021 | Grab 2 | SCA | 2 | SB-SCA-02-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 10.000000 | NaN | 40.268871 | -106.883927 | NaN | 2021 | #ff7f0e |
| 12 | Yampa Valley | 7/28/2021 | Grab 2 | SCB | 1 | SB-SCB-02-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 156.666667 | NaN | 40.285571 | -106.829854 | NaN | 2021 | #2ca02c |
| 13 | Yampa Valley | 7/28/2021 | Grab 2 | SCB | 2 | SB-SCB-02-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 13.333333 | NaN | 40.285571 | -106.829854 | NaN | 2021 | #2ca02c |
| 14 | Yampa Valley | 7/28/2021 | Grab 2 | DS | 1 | SB-DS-02-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 13.333333 | NaN | 40.289025 | -106.819500 | NaN | 2021 | #d62728 |
| 15 | Yampa Valley | 7/28/2021 | Grab 2 | DS | 2 | SB-DS-02-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 6.666667 | NaN | 40.289025 | -106.819500 | NaN | 2021 | #d62728 |
| 16 | Yampa Valley | 7/28/2021 | Grab 2 | CM | 1 | SB-CM-02-GB | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 16.666667 | NaN | 40.364350 | -106.799157 | NaN | 2021 | #9467bd |
| 17 | Yampa Valley | 7/28/2021 | Grab 2 | CM | 2 | SB-CM-02-GB-D | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | 6.666667 | NaN | 40.364350 | -106.799157 | NaN | 2021 | #9467bd |
18 rows × 21 columns